DateTime
Crystal syntax.
The CDateTime and DateTimeValue functions are equivalent to DateTime. However, DateTime can only be used in Crystal syntax since it is a type name in Basic syntax.
Overloads
- DateTime (date)
- DateTime (number)
- DateTime (string)
- DateTime (date, time)
- DateTime (YYYY, MM, DD)
- DateTime (YYYY, MM, DD, HH, MM, SS)
Arguments
DateTime (date)
| date is a Date value.
|
DateTime (date, time)
| - date is a Date value.
- time is a Time value.
|
DateTime (string)
| string represents a date and time
Example: "September 15, 1999, 10:45a.m."
|
DateTime (number)
| number represents a number of days from December 30, 1899.
Example: 20 represents 20 days from December, 1899, which is January 19, 1900.
|
DateTime (year, month, day)
DateTime (year, month, day, hour, min, sec)
| - year is a whole number representing a calendar year, example: 1996.
- month is a whole number representing a month, example: 1 for January.
- day is a whole number representing a day of the month, example: 10.
- hour is a whole number representing an hour of the day, example: 12.
- min is a whole number representing a minute, example: 59.
- sec is a whole number representing seconds, example: 30.
|
Returns
DateTime value.
Action
DateTime (date)
| Returns a DateTime value given a Date value, assigning 12:00:00 AM for the time portion for the returned DateTime value.
|
DateTime (date, time)
| Returns a DateTime value given a Date and a Time value.
|
DateTime (number)
| Returns a DateTime value given a number that specifies the number of days from December 30, 1899.
Number can be positive or negative, and can be fractional.
|
DateTime (string)
| Returns a DateTime value given a string that specifies a date and time; various formats of the string are supported.
|
DateTime (YYYY, MM, DD)
| Returns a DateTime value given numeric arguments for the year, month and day.
Assigns 12:00:00 AM for the time portion for the returned DateTime value.
|
DateTime (YYYY, MM, DD, HH, MM, SS)
| Returns a DateTime value given numeric arguments for the year, month, day, hour, minute and second.
|
Examples
The following examples are applicable to Crystal syntax:
DateTime ("10/4/1999 10:20am")
Returns the DateTime value October 4, 1999 10:20:00 am.
DateTime (12.5)
Returns the DateTime value January 11, 1900 12:00:00 pm.
DateTime (-2.5)
Returns the DateTime value December 27, 1899, 12:00:00 pm.
DateTime (CDate ("Dec. 25, 1999"))
Returns the DateTime value December 25, 1999 12:00:00 am.
DateTime (CDate ("November 10, 1999"), CTime("12:20am"))
Returns the DateTime value November 10, 1999 12:20:00 am.
DateTime (1945, 8, 21, 0, 0, 0)
Returns the DateTime value August 21, 1945 12:00:00 am.
DateTime (1945, 8, 21, 10, 0, 0)
Returns the DateTime value August 21, 1945 10:00:00 am.
Comments
You can use the IsDateTime function to check if a String argument can be converted to a DateTime before doing the actual conversion. That way, if the conversion cannot be done, you can handle the situation appropriately.
Related topics
DateTimeValue